/****** Object:  Table [dbo].[FIGYELEM]    Script Date: 08/03/2008 12:08:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FIGYELEM](
	[FGY_ID] [int] IDENTITY(1,1) NOT NULL,
	[FGY_TIPUS] [varchar](5) COLLATE SQL_Hungarian_CP1250_CS_AS NOT NULL,
	[FGY_USR_ID] [int] NOT NULL,
	[FGY_PRT_ID] [int] NULL,
	[FGY_FIGY_DATUM] [datetime] NULL,
	[FGY_MEGJEGYZES] [varchar](100) COLLATE SQL_Hungarian_CP1250_CS_AS NOT NULL CONSTRAINT [DF_FIGYELEM_FGY_MEGJEGYZES]  DEFAULT (''),
	[FGY_CREATED] [datetime] NOT NULL,
	[FGY_STATUS] [varchar](1) COLLATE SQL_Hungarian_CP1250_CS_AS NOT NULL,
	[FGY_OLVASVA] [datetime] NULL,
 CONSTRAINT [PK_FIGYELEM] PRIMARY KEY CLUSTERED 
(
	[FGY_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF